Overview

Dataset info

Number of variables29
Number of observations21201
Missing cells25015 (4.1%)
Duplicate rows0 (0.0%)
Total size in memory4.7 MiB
Average record size in memory232.0 B

Variables types

Numeric10
Categorical9
Boolean0
Date0
URL0
Text (Unique)1
Rejected9
Unsupported0

Warnings

Arrival_at_Destination_-_Time only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
Arrival_at_Destination_-_Time has a high cardinality: 15725 distinct values Warning
Arrival_at_Pickup_-_Day_of_Month is highly correlated with Arrival_at_Destination_-_Day_of_Month (ρ = 1) Rejected
Arrival_at_Pickup_-_Time only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
Arrival_at_Pickup_-_Time has a high cardinality: 15767 distinct values Warning
Arrival_at_Pickup_-_Weekday_(Mo_=_1) is highly correlated with Arrival_at_Destination_-_Weekday_(Mo_=_1) (ρ = 1) Rejected
Confirmation_-_Day_of_Month is highly correlated with Arrival_at_Pickup_-_Day_of_Month (ρ = 1) Rejected
Confirmation_-_Time only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
Confirmation_-_Time has a high cardinality: 15742 distinct values Warning
Confirmation_-_Weekday_(Mo_=_1) is highly correlated with Arrival_at_Pickup_-_Weekday_(Mo_=_1) (ρ = 1) Rejected
Pickup_-_Day_of_Month is highly correlated with Confirmation_-_Day_of_Month (ρ = 1) Rejected
Pickup_-_Time only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
Pickup_-_Time has a high cardinality: 15690 distinct values Warning
Pickup_-_Weekday_(Mo_=_1) is highly correlated with Confirmation_-_Weekday_(Mo_=_1) (ρ = 1) Rejected
Placement_-_Day_of_Month is highly correlated with Pickup_-_Day_of_Month (ρ = 0.999998477) Rejected
Placement_-_Time only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
Placement_-_Time has a high cardinality: 15686 distinct values Warning
Placement_-_Weekday_(Mo_=_1) is highly correlated with Pickup_-_Weekday_(Mo_=_1) (ρ = 0.9999519962) Rejected
Precipitation_in_millimeters has 20649 (97.4%) missing values Missing
Rider_Id has a high cardinality: 924 distinct values Warning
Temperature has 4366 (20.6%) missing values Missing
User_Id has a high cardinality: 3186 distinct values Warning
Vehicle_Type has constant value "Bike" Rejected

Variables

Arrival_at_Destination_-_Day_of_Month
Numeric

Distinct count31
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean15.65383708
Minimum1
Maximum31
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q18
Median15
Q323
95-th percentile30
Maximum31
Range30
Interquartile range15

Descriptive statistics

Standard deviation8.798886375
Coef of variation0.5620913472
Kurtosis-1.2074902
Mean15.65383708
MAD7.633175565
Skewness0.09103408839
Sum331877
Variance77.42040143
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=31)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 5.5 8.5 ... 17.5 18.5 24.5 30.5 31. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
8 848 4.0%
 
7 822 3.9%
 
13 812 3.8%
 
14 804 3.8%
 
6 794 3.7%
 
28 784 3.7%
 
18 770 3.6%
 
4 769 3.6%
 
15 762 3.6%
 
11 751 3.5%
 
Other values (21) 13285 62.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 482 2.3%
 
2 602 2.8%
 
3 718 3.4%
 
4 769 3.6%
 
5 747 3.5%
 

Maximum 5 values

ValueCountFrequency (%) 
31 453 2.1%
 
30 714 3.4%
 
29 685 3.2%
 
28 784 3.7%
 
27 670 3.2%
 

Arrival_at_Destination_-_Time
Categorical

Distinct count15725
Unique (%)74.2%
Missing (%)0.0%
Missing (n)0
3:24:03 PM
 
7
1:08:03 PM
 
6
11:16:33 AM
 
6
Other values (15722)
21182
ValueCountFrequency (%) 
3:24:03 PM 7 < 0.1%
 
1:08:03 PM 6 < 0.1%
 
11:16:33 AM 6 < 0.1%
 
1:25:43 PM 6 < 0.1%
 
11:22:45 AM 5 < 0.1%
 
3:08:49 PM 5 < 0.1%
 
2:42:57 PM 5 < 0.1%
 
11:35:08 AM 5 < 0.1%
 
1:05:44 PM 5 < 0.1%
 
4:07:22 PM 5 < 0.1%
 
Other values (15715) 21146 99.7%
 
Max length11
Mean length10.35017216
Min length10
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Arrival_at_Destination_-_Weekday_(Mo_=_1)
Numeric

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.240224518
Minimum1
Maximum7
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median3
Q35
95-th percentile6
Maximum7
Range6
Interquartile range3

Descriptive statistics

Standard deviation1.567228303
Coef of variation0.4836789223
Kurtosis-1.024853597
Mean3.240224518
MAD1.350351179
Skewness0.1104716065
Sum68696
Variance2.456204553
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=7)
Histogram
Histogram with variable size bins (bins=[1. 1.5 3.5 5.5 6.5 7. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
4 4229 19.9%
 
5 3993 18.8%
 
2 3959 18.7%
 
3 3823 18.0%
 
1 3788 17.9%
 
6 1223 5.8%
 
7 186 0.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 3788 17.9%
 
2 3959 18.7%
 
3 3823 18.0%
 
4 4229 19.9%
 
5 3993 18.8%
 

Maximum 5 values

ValueCountFrequency (%) 
7 186 0.9%
 
6 1223 5.8%
 
5 3993 18.8%
 
4 4229 19.9%
 
3 3823 18.0%
 

Arrival_at_Pickup_-_Day_of_Month
Highly correlated

This variable is highly correlated with Arrival_at_Destination_-_Day_of_Month and should be ignored for analysis

Correlation1

Arrival_at_Pickup_-_Time
Categorical

Distinct count15767
Unique (%)74.4%
Missing (%)0.0%
Missing (n)0
3:02:41 PM
 
6
2:42:41 PM
 
6
2:10:11 PM
 
6
Other values (15764)
21183
ValueCountFrequency (%) 
3:02:41 PM 6 < 0.1%
 
2:42:41 PM 6 < 0.1%
 
2:10:11 PM 6 < 0.1%
 
1:02:53 PM 6 < 0.1%
 
2:32:04 PM 6 < 0.1%
 
2:52:44 PM 5 < 0.1%
 
3:33:04 PM 5 < 0.1%
 
3:05:00 PM 5 < 0.1%
 
10:22:40 AM 5 < 0.1%
 
9:56:09 AM 5 < 0.1%
 
Other values (15757) 21146 99.7%
 
Max length11
Mean length10.37234093
Min length10
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Arrival_at_Pickup_-_Weekday_(Mo_=_1)
Highly correlated

This variable is highly correlated with Arrival_at_Destination_-_Weekday_(Mo_=_1) and should be ignored for analysis

Correlation1

Confirmation_-_Day_of_Month
Highly correlated

This variable is highly correlated with Arrival_at_Pickup_-_Day_of_Month and should be ignored for analysis

Correlation1

Confirmation_-_Time
Categorical

Distinct count15742
Unique (%)74.3%
Missing (%)0.0%
Missing (n)0
9:56:52 AM
 
6
3:47:50 PM
 
5
3:45:01 PM
 
5
Other values (15739)
21185
ValueCountFrequency (%) 
9:56:52 AM 6 < 0.1%
 
3:47:50 PM 5 < 0.1%
 
3:45:01 PM 5 < 0.1%
 
11:21:38 AM 5 < 0.1%
 
3:20:53 PM 5 < 0.1%
 
10:18:08 AM 5 < 0.1%
 
2:28:37 PM 5 < 0.1%
 
11:07:48 AM 5 < 0.1%
 
12:02:59 PM 5 < 0.1%
 
3:48:00 PM 5 < 0.1%
 
Other values (15732) 21150 99.8%
 
Max length11
Mean length10.37606717
Min length10
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Confirmation_-_Weekday_(Mo_=_1)
Highly correlated

This variable is highly correlated with Arrival_at_Pickup_-_Weekday_(Mo_=_1) and should be ignored for analysis

Correlation1

Destination_Lat
Numeric

Distinct count5302
Unique (%)25.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean-1.282580838
Minimum-1.4302983
Maximum-1.0302254
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-1.4302983
5-th percentile-1.3366311
Q1-1.3012008
Median-1.284382
Q3-1.261177
95-th percentile-1.225322
Maximum-1.0302254
Range0.4000729
Interquartile range0.0400238

Descriptive statistics

Standard deviation0.03482356811
Coef of variation-0.02715116824
Kurtosis2.266756264
Mean-1.282580838
MAD0.02642191732
Skewness0.1723612574
Sum-27191.99635
Variance0.001212680896
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-1.4302983 -1.39892515 -1.3884176 -1.38816995 -1.374376 ... -1.1771735 -1.14351545 -1.14261725 -1.1080432 -1.0302254 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-1.3004062 579 2.7%
 
-1.2551895 529 2.5%
 
-1.2638185 297 1.4%
 
-1.265715 274 1.3%
 
-1.2600926 269 1.3%
 
-1.2571472 263 1.2%
 
-1.2628473 263 1.2%
 
-1.306378 231 1.1%
 
-1.2991441 214 1.0%
 
-1.2584143 204 1.0%
 
Other values (5292) 18078 85.3%
 

Minimum 5 values

ValueCountFrequency (%) 
-1.4302983 1 < 0.1%
 
-1.4287625 1 < 0.1%
 
-1.4242042 2 < 0.1%
 
-1.4238401 1 < 0.1%
 
-1.4196538 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
-1.0302254 1 < 0.1%
 
-1.0352624 1 < 0.1%
 
-1.0546336 2 < 0.1%
 
-1.0568484 1 < 0.1%
 
-1.0921599 5 < 0.1%
 

Destination_Long
Numeric

Distinct count5267
Unique (%)24.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean36.81122
Minimum36.6065939
Maximum37.0167793
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum36.6065939
5-th percentile36.7519845
Q136.7856612
Median36.8080021
Q336.829477
95-th percentile36.897607
Maximum37.0167793
Range0.4101854
Interquartile range0.0438158

Descriptive statistics

Standard deviation0.04472064173
Coef of variation0.001214864428
Kurtosis1.340514535
Mean36.81122
MAD0.03251410604
Skewness0.4078052915
Sum780434.6751
Variance0.001999935797
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[36.6065939 36.651528 36.6871329 36.68718305 36.689407 ... 36.9572557 36.9669432 36.9672963 36.970926 37.0167793 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
36.829741 579 2.7%
 
36.7822034 529 2.5%
 
36.7930057 296 1.4%
 
36.823815 269 1.3%
 
36.8088685 269 1.3%
 
36.781805 263 1.2%
 
36.7950633 263 1.2%
 
36.7519845 231 1.1%
 
36.7528804 214 1.0%
 
36.8048002 204 1.0%
 
Other values (5257) 18084 85.3%
 

Minimum 5 values

ValueCountFrequency (%) 
36.6065939 1 < 0.1%
 
36.6308896 1 < 0.1%
 
36.6402664 1 < 0.1%
 
36.6405079 1 < 0.1%
 
36.6426562 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
37.0167793 1 < 0.1%
 
37.0120302 2 < 0.1%
 
37.0109232 1 < 0.1%
 
37.0108117 1 < 0.1%
 
37.0056922 1 < 0.1%
 

Distance_(KM)
Numeric

Distinct count45
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean9.506532711
Minimum1
Maximum49
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q15
Median8
Q313
95-th percentile20
Maximum49
Range48
Interquartile range8

Descriptive statistics

Standard deviation5.668962773
Coef of variation0.5963228599
Kurtosis1.458819669
Mean9.506532711
MAD4.480305835
Skewness1.085025791
Sum201548
Variance32.13713893
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=45)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 24.5 28.5 30.5 37.5 49. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
8 1973 9.3%
 
5 1929 9.1%
 
6 1726 8.1%
 
4 1675 7.9%
 
7 1672 7.9%
 
9 1463 6.9%
 
10 1162 5.5%
 
3 1111 5.2%
 
11 1030 4.9%
 
14 950 4.5%
 
Other values (35) 6510 30.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 307 1.4%
 
2 770 3.6%
 
3 1111 5.2%
 
4 1675 7.9%
 
5 1929 9.1%
 

Maximum 5 values

ValueCountFrequency (%) 
49 1 < 0.1%
 
48 1 < 0.1%
 
46 1 < 0.1%
 
44 1 < 0.1%
 
41 2 < 0.1%
 

Order_No
Categorical, Unique

First 5 values
Order_No_1
Order_No_10
Order_No_100
Order_No_1000
Order_No_10000
Last 5 values
Order_No_9992
Order_No_9993
Order_No_9995
Order_No_9996
Order_No_9997

First 5 values

ValueCountFrequency (%) 
Order_No_1 1 < 0.1%
 
Order_No_10 1 < 0.1%
 
Order_No_100 1 < 0.1%
 
Order_No_1000 1 < 0.1%
 
Order_No_10000 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
Order_No_9997 1 < 0.1%
 
Order_No_9996 1 < 0.1%
 
Order_No_9995 1 < 0.1%
 
Order_No_9993 1 < 0.1%
 
Order_No_9992 1 < 0.1%
 

Personal_or_Business
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Business
17384
Personal
3817
ValueCountFrequency (%) 
Business 17384 82.0%
 
Personal 3817 18.0%
 
Max length8
Mean length8
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

Pickup_-_Day_of_Month
Highly correlated

This variable is highly correlated with Confirmation_-_Day_of_Month and should be ignored for analysis

Correlation1

Pickup_-_Time
Categorical

Distinct count15690
Unique (%)74.0%
Missing (%)0.0%
Missing (n)0
12:04:20 PM
 
6
10:53:20 AM
 
6
2:28:10 PM
 
6
Other values (15687)
21183
ValueCountFrequency (%) 
12:04:20 PM 6 < 0.1%
 
10:53:20 AM 6 < 0.1%
 
2:28:10 PM 6 < 0.1%
 
11:19:28 AM 6 < 0.1%
 
3:14:23 PM 5 < 0.1%
 
4:15:10 PM 5 < 0.1%
 
3:01:12 PM 5 < 0.1%
 
1:10:24 PM 5 < 0.1%
 
3:22:34 PM 5 < 0.1%
 
12:10:43 PM 5 < 0.1%
 
Other values (15680) 21147 99.7%
 
Max length11
Mean length10.37069006
Min length10
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Pickup_-_Weekday_(Mo_=_1)
Highly correlated

This variable is highly correlated with Confirmation_-_Weekday_(Mo_=_1) and should be ignored for analysis

Correlation1

Pickup_Lat
Numeric

Distinct count3666
Unique (%)17.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean-1.281469693
Minimum-1.4383017
Maximum-1.1471704
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-1.4383017
5-th percentile-1.3302996
Q1-1.300921
Median-1.279395
Q3-1.2571472
95-th percentile-1.2297202
Maximum-1.1471704
Range0.2911313
Interquartile range0.0437738

Descriptive statistics

Standard deviation0.03050707731
Coef of variation-0.02380631979
Kurtosis0.8191796651
Mean-1.281469693
MAD0.0246201832
Skewness-0.2291906139
Sum-27168.43896
Variance0.0009306817659
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-1.4383017 -1.4005813 -1.38853185 -1.38802565 -1.37087495 ... -1.2074713 -1.18554965 -1.18543495 -1.16127185 -1.1471704 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-1.2551895 2429 11.5%
 
-1.2571472 629 3.0%
 
-1.3167113 597 2.8%
 
-1.300921 528 2.5%
 
-1.3004062 510 2.4%
 
-1.2584143 412 1.9%
 
-1.272639 291 1.4%
 
-1.290894 259 1.2%
 
-1.279395 217 1.0%
 
-1.273056 207 1.0%
 
Other values (3656) 15122 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
-1.4383017 1 < 0.1%
 
-1.4332561 1 < 0.1%
 
-1.428932 1 < 0.1%
 
-1.4242042 1 < 0.1%
 
-1.4226525 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
-1.1471704 1 < 0.1%
 
-1.1490105 1 < 0.1%
 
-1.1518113 1 < 0.1%
 
-1.1538233 1 < 0.1%
 
-1.15393 1 < 0.1%
 

Pickup_Long
Numeric

Distinct count3656
Unique (%)17.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean36.81126359
Minimum36.653621
Maximum36.9910462
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum36.653621
5-th percentile36.764868
Q136.7846054
Median36.8070399
Q336.829741
95-th percentile36.8863135
Maximum36.9910462
Range0.3374252
Interquartile range0.0451356

Descriptive statistics

Standard deviation0.03747255524
Coef of variation0.001017964383
Kurtosis1.454746096
Mean36.81126359
MAD0.02816052045
Skewness0.5462831696
Sum780435.5994
Variance0.001404192396
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[36.653621 36.6994482 36.7004773 36.7109811 36.71113455 ... 36.9159949 36.91870415 36.9191933 36.9715278 36.9910462 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
36.7822034 2429 11.5%
 
36.7950633 629 3.0%
 
36.8301563 597 2.8%
 
36.828195 528 2.5%
 
36.829741 510 2.4%
 
36.8048002 412 1.9%
 
36.794723 291 1.4%
 
36.822971 259 1.2%
 
36.825364 216 1.0%
 
36.811298 207 1.0%
 
Other values (3646) 15123 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
36.653621 1 < 0.1%
 
36.6538278 1 < 0.1%
 
36.6647806 1 < 0.1%
 
36.6654506 1 < 0.1%
 
36.6664253 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
36.9910462 1 < 0.1%
 
36.9806911 1 < 0.1%
 
36.9759716 1 < 0.1%
 
36.967084 13 0.1%
 
36.9647412 1 < 0.1%
 

Placement_-_Day_of_Month
Highly correlated

This variable is highly correlated with Pickup_-_Day_of_Month and should be ignored for analysis

Correlation0.999998477

Placement_-_Time
Categorical

Distinct count15686
Unique (%)74.0%
Missing (%)0.0%
Missing (n)0
2:57:22 PM
 
6
10:31:43 AM
 
6
2:24:11 PM
 
6
Other values (15683)
21183
ValueCountFrequency (%) 
2:57:22 PM 6 < 0.1%
 
10:31:43 AM 6 < 0.1%
 
2:24:11 PM 6 < 0.1%
 
9:41:03 AM 6 < 0.1%
 
12:51:03 PM 6 < 0.1%
 
2:06:19 PM 6 < 0.1%
 
11:45:52 AM 5 < 0.1%
 
2:26:53 PM 5 < 0.1%
 
2:39:54 PM 5 < 0.1%
 
2:30:43 PM 5 < 0.1%
 
Other values (15676) 21145 99.7%
 
Max length11
Mean length10.37988774
Min length10
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Placement_-_Weekday_(Mo_=_1)
Highly correlated

This variable is highly correlated with Pickup_-_Weekday_(Mo_=_1) and should be ignored for analysis

Correlation0.9999519962

Platform_Type
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
3
18054
1
 
2147
2
 
980
ValueCountFrequency (%) 
3 18054 85.2%
 
1 2147 10.1%
 
2 980 4.6%
 
4 20 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Precipitation_in_millimeters
Numeric

Distinct count55
Unique (%)0.3%
Missing (%)97.4%
Missing (n)20649
Infinite (%)0.0%
Infinite (n)0
Mean7.905797101
Minimum0.1
Maximum99.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.1
5-th percentile0.3
Q11.075
Median2.9
Q34.9
95-th percentile50.945
Maximum99.1
Range99
Interquartile range3.825

Descriptive statistics

Standard deviation17.08997124
Coef of variation2.16170122
Kurtosis15.73944046
Mean7.905797101
MAD9.058433102
Skewness3.908902069
Sum4364
Variance292.067117
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2 39 0.2%
 
1.9 37 0.2%
 
0.9 35 0.2%
 
1.1 34 0.2%
 
3 29 0.1%
 
3.1 27 0.1%
 
2.1 25 0.1%
 
2.9 22 0.1%
 
1 21 0.1%
 
3.9 19 0.1%
 
Other values (44) 264 1.2%
 
(Missing) 20649 97.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0.1 6 < 0.1%
 
0.2 9 < 0.1%
 
0.3 18 0.1%
 
0.4 12 0.1%
 
0.5 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
99.1 3 < 0.1%
 
99 1 < 0.1%
 
98.9 5 < 0.1%
 
83.1 2 < 0.1%
 
83 2 < 0.1%
 

Rider_Id
Categorical

Distinct count924
Unique (%)4.4%
Missing (%)0.0%
Missing (n)0
Rider_Id_726
 
247
Rider_Id_576
 
223
Rider_Id_523
 
199
Other values (921)
20532
ValueCountFrequency (%) 
Rider_Id_726 247 1.2%
 
Rider_Id_576 223 1.1%
 
Rider_Id_523 199 0.9%
 
Rider_Id_101 183 0.9%
 
Rider_Id_205 182 0.9%
 
Rider_Id_882 172 0.8%
 
Rider_Id_427 168 0.8%
 
Rider_Id_116 158 0.7%
 
Rider_Id_88 152 0.7%
 
Rider_Id_103 151 0.7%
 
Other values (914) 19366 91.3%
 
Max length12
Mean length11.8805245
Min length10
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Temperature
Numeric

Distinct count189
Unique (%)0.9%
Missing (%)20.6%
Missing (n)4366
Infinite (%)0.0%
Infinite (n)0
Mean23.25888922
Minimum11.2
Maximum32.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum11.2
5-th percentile17.3
Q120.6
Median23.5
Q326
95-th percentile28.73
Maximum32.1
Range20.9
Interquartile range5.4

Descriptive statistics

Standard deviation3.615768283
Coef of variation0.155457479
Kurtosis-0.5743438517
Mean23.25888922
MAD2.991490797
Skewness-0.1536427098
Sum391563.4
Variance13.07378028
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
24.7 201 0.9%
 
22.4 196 0.9%
 
23.8 195 0.9%
 
23.7 191 0.9%
 
24.6 189 0.9%
 
23.6 188 0.9%
 
25.2 184 0.9%
 
22.5 183 0.9%
 
27.3 179 0.8%
 
24.8 178 0.8%
 
Other values (178) 14951 70.5%
 
(Missing) 4366 20.6%
 

Minimum 5 values

ValueCountFrequency (%) 
11.2 1 < 0.1%
 
13.2 5 < 0.1%
 
13.3 6 < 0.1%
 
13.4 5 < 0.1%
 
13.5 4 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
32.1 4 < 0.1%
 
32 2 < 0.1%
 
31.9 2 < 0.1%
 
31.8 6 < 0.1%
 
31.7 3 < 0.1%
 

Time_from_Pickup_to_Arrival
Numeric

Distinct count4067
Unique (%)19.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1556.920947
Minimum1
Maximum7883
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile285
Q1882
Median1369
Q32040
95-th percentile3499
Maximum7883
Range7882
Interquartile range1158

Descriptive statistics

Standard deviation987.2707879
Coef of variation0.6341174802
Kurtosis2.236351987
Mean1556.920947
MAD749.1729935
Skewness1.201937919
Sum33008281
Variance974703.6086
Memory size165.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.0000e+00 3.5000e+00 5.5000e+00 1.0500e+01 1.5500e+01 ... 4.0325e+03 4.8245e+03 5.1485e+03 5.9195e+03 7.8830e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2 143 0.7%
 
3 97 0.5%
 
4 66 0.3%
 
5 56 0.3%
 
7 37 0.2%
 
1 37 0.2%
 
6 36 0.2%
 
8 29 0.1%
 
10 25 0.1%
 
1424 24 0.1%
 
Other values (4057) 20651 97.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 37 0.2%
 
2 143 0.7%
 
3 97 0.5%
 
4 66 0.3%
 
5 56 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
7883 1 < 0.1%
 
7714 1 < 0.1%
 
7646 1 < 0.1%
 
7491 1 < 0.1%
 
7387 1 < 0.1%
 

User_Id
Categorical

Distinct count3186
Unique (%)15.0%
Missing (%)0.0%
Missing (n)0
User_Id_393
 
645
User_Id_2330
 
322
User_Id_3647
 
312
Other values (3183)
19922
ValueCountFrequency (%) 
User_Id_393 645 3.0%
 
User_Id_2330 322 1.5%
 
User_Id_3647 312 1.5%
 
User_Id_1500 301 1.4%
 
User_Id_635 290 1.4%
 
User_Id_868 278 1.3%
 
User_Id_3291 276 1.3%
 
User_Id_3283 268 1.3%
 
User_Id_136 211 1.0%
 
User_Id_1329 208 1.0%
 
Other values (3176) 18090 85.3%
 
Max length12
Mean length11.67492099
Min length9
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Vehicle_Type
Constant

This variable is constant and should be ignored for analysis

Constant valueBike

Correlations

Missing values

Sample

First rows

Arrival_at_Destination_-_Day_of_MonthArrival_at_Destination_-_TimeArrival_at_Destination_-_Weekday_(Mo_=_1)Arrival_at_Pickup_-_Day_of_MonthArrival_at_Pickup_-_TimeArrival_at_Pickup_-_Weekday_(Mo_=_1)Confirmation_-_Day_of_MonthConfirmation_-_TimeConfirmation_-_Weekday_(Mo_=_1)Destination_LatDestination_LongDistance_(KM)Order_NoPersonal_or_BusinessPickup_-_Day_of_MonthPickup_-_TimePickup_-_Weekday_(Mo_=_1)Pickup_LatPickup_LongPlacement_-_Day_of_MonthPlacement_-_TimePlacement_-_Weekday_(Mo_=_1)Platform_TypePrecipitation_in_millimetersRider_IdTemperatureTime_from_Pickup_to_ArrivalUser_IdVehicle_Type
0910:39:55 AM5910:04:47 AM599:40:10 AM5-1.30040636.8297414Order_No_4211Business910:27:30 AM5-1.31775536.83037099:35:46 AM53NaNRider_Id_43220.4745User_Id_633Bike
11212:17:22 PM51211:40:22 AM51211:23:21 AM5-1.29500436.81435816Order_No_25375Personal1211:44:09 AM5-1.35145336.8993151211:16:16 AM53NaNRider_Id_85626.41993User_Id_2285Bike
2301:00:38 PM23012:49:34 PM23012:42:44 PM2-1.30092136.8281953Order_No_1899Business3012:53:03 PM2-1.30828436.8434193012:39:25 PM23NaNRider_Id_155NaN455User_Id_265Bike
31510:05:27 AM5159:37:56 AM5159:26:05 AM5-1.25714736.7950639Order_No_9336Business159:43:06 AM5-1.28130136.832396159:25:34 AM53NaNRider_Id_85519.21341User_Id_1402Bike
41310:25:37 AM11310:03:53 AM1139:56:18 AM1-1.29504136.8098179Order_No_27883Personal1310:05:23 AM1-1.26659736.792118139:55:18 AM11NaNRider_Id_77015.41214User_Id_1737Bike
5144:23:41 PM5143:21:36 PM5143:08:57 PM5-1.25730936.8060089Order_No_7408Business143:30:30 PM5-1.30258336.767081143:07:35 PM53NaNRider_Id_12427.23191User_Id_1342Bike
6910:19:45 AM599:53:12 AM599:49:47 AM5-1.27657436.8513655Order_No_22680Business99:56:45 AM5-1.27939536.82536499:33:45 AM53NaNRider_Id_11420.31380User_Id_2803Bike
7112:33:26 PM1112:21:33 PM1112:14:13 PM1-1.25518936.7822033Order_No_21578Business112:22:40 PM1-1.25279636.800313112:13:01 PM13NaNRider_Id_91328.7646User_Id_1075Bike
8301:19:35 PM23012:13:18 PM23011:15:49 AM2-1.30025536.8256579Order_No_5234Business3012:22:57 PM2-1.25518936.7822033011:10:44 AM23NaNRider_Id_394NaN3398User_Id_733Bike
9236:31:57 PM5235:32:41 PM5235:17:56 PM5-1.21560136.89168614Order_No_1768Business235:34:38 PM5-1.22532236.808550234:48:54 PM53NaNRider_Id_66024.63439User_Id_2112Bike

Last rows

Arrival_at_Destination_-_Day_of_MonthArrival_at_Destination_-_TimeArrival_at_Destination_-_Weekday_(Mo_=_1)Arrival_at_Pickup_-_Day_of_MonthArrival_at_Pickup_-_TimeArrival_at_Pickup_-_Weekday_(Mo_=_1)Confirmation_-_Day_of_MonthConfirmation_-_TimeConfirmation_-_Weekday_(Mo_=_1)Destination_LatDestination_LongDistance_(KM)Order_NoPersonal_or_BusinessPickup_-_Day_of_MonthPickup_-_TimePickup_-_Weekday_(Mo_=_1)Pickup_LatPickup_LongPlacement_-_Day_of_MonthPlacement_-_TimePlacement_-_Weekday_(Mo_=_1)Platform_TypePrecipitation_in_millimetersRider_IdTemperatureTime_from_Pickup_to_ArrivalUser_IdVehicle_Type
2119113:39:55 PM412:51:53 PM412:10:27 PM4-1.21560136.89168613Order_No_16262Business12:53:08 PM4-1.28214236.81615612:09:37 PM43NaNRider_Id_736NaN2807User_Id_1231Bike
21192231:21:22 PM22312:44:19 PM22312:41:52 PM2-1.30832736.8494767Order_No_11670Business231:05:11 PM2-1.31671136.8301562312:41:17 PM23NaNRider_Id_571NaN971User_Id_1146Bike
21193125:56:53 PM6125:06:48 PM6124:49:51 PM6-1.30010636.75845510Order_No_4988Personal125:27:22 PM6-1.28656836.825335124:48:16 PM61NaNRider_Id_10323.51771User_Id_875Bike
21194155:53:33 PM1155:08:13 PM1155:02:52 PM1-1.31986236.71103216Order_No_865Business155:15:15 PM1-1.26023436.799055155:02:09 PM13NaNRider_Id_177NaN2298User_Id_1245Bike
2119522:33:21 PM621:52:11 PM621:25:40 PM6-1.27654936.76698117Order_No_9932Business21:54:36 PM6-1.23840636.87187021:08:34 PM63NaNRider_Id_3429.02325User_Id_3582Bike
21196204:20:17 PM3203:58:49 PM3203:55:09 PM3-1.27528536.8027023Order_No_8834Personal204:20:08 PM3-1.25841436.804800203:54:38 PM33NaNRider_Id_95328.69User_Id_2001Bike
211971310:46:17 AM61310:20:04 AM61310:13:41 AM6-1.33161936.8479767Order_No_22892Business1310:33:27 AM6-1.30714336.8250091310:13:34 AM63NaNRider_Id_15526.0770User_Id_1796Bike
2119876:40:05 PM475:30:17 PM475:07:09 PM4-1.25841436.80480020Order_No_2831Business75:50:52 PM4-1.28601836.89753475:06:16 PM43NaNRider_Id_69729.22953User_Id_2956Bike
21199410:08:15 AM349:38:59 AM349:31:53 AM3-1.27920936.79487213Order_No_6174Personal49:45:15 AM3-1.25003036.87416749:31:39 AM31NaNRider_Id_34715.01380User_Id_2524Bike
21200263:17:23 PM2262:24:29 PM2262:20:01 PM2-1.32015736.83088712Order_No_9836Business262:41:55 PM2-1.25518936.782203262:19:47 PM23NaNRider_Id_17730.92128User_Id_718Bike